﻿CREATE TABLE [dbo].[Message]
(
	[MessageID] BIGINT IDENTITY(1,1) NOT NULL CONSTRAINT [dbo_Message_MessageID] PRIMARY KEY, 
	[Author] NVARCHAR(250) NOT NULL CONSTRAINT [dbo_Message_Author] DEFAULT ('UNKNOWN'), 
	[Body] NVARCHAR(1000) NOT NULL CONSTRAINT [dbo_Message_Body] DEFAULT ('NONE'), 
	[BodyHTML] NVARCHAR(1000) NOT NULL CONSTRAINT [dbo_Message_BodyHTML] DEFAULT ('NONE'), 
	[Context] NVARCHAR(250) NOT NULL CONSTRAINT [dbo_Message_Context] DEFAULT ('NONE'), 
	[FirstMessage] NVARCHAR(250) NOT NULL CONSTRAINT [dbo_Message_FM] DEFAULT ('NONE'), 
	[Likes] BIT NOT NULL CONSTRAINT [dbo_Message_Likes] DEFAULT ('False'), 
	[LinkTitle] NVARCHAR(1000) NOT NULL CONSTRAINT [dbo_Message_LT] DEFAULT ('UNKNOWN'), 
	[Name] NVARCHAR(250) NOT NULL CONSTRAINT [dbo_Message_Name] UNIQUE, 
	[New] BIT NOT NULL CONSTRAINT [dbo_Message_New] DEFAULT ('False'), 
	[ParentID] BIGINT NOT NULL, 
	[Replies] NVARCHAR(250) NOT NULL CONSTRAINT [dbo_Message_Replies] DEFAULT ('NONE'), 
	[Subject] NVARCHAR(250) NOT NULL CONSTRAINT [dbo_Message_Subject] DEFAULT ('NONE'), 
	[Subreddit] NVARCHAR(250) NOT NULL CONSTRAINT [dbo_Message_Subreddit] DEFAULT ('UNKNOWN'), 
	[WasComment] BIT NOT NULL CONSTRAINT [dbo_Message_WC] DEFAULT ('False')
)
